I have a mysql table that has 2 columns - Column 1 contains a string value, and Column 2 contains the number of times that string value occurred.

I'm trying to find the string abc.X.def, where the beginning of the string is "abc.", followed by one or more characters, then the string ".def". There could be more characters following ".def".

How can I find such strings, then add the occurrence of such strings and display the results?

For example, if I have

abc.111.def23   1
abc.111.def     2
abc.22.def444   1
abc.111.def     1

Then I will get

abc.111.def23   1
abc.111.def     3
abc.22.def444   1

Thank you.